StockBorrowRate

V8 Message Definiton

This data is sourced from various clearing firms and typically represents their public borrow rates. Data is typically loaded once at the start of each trading day. StockBorrowRate records are published to the SpiderRock elastic cluster at the end of each trading period.

METADATA

Attribute	Value
Topic	1725-client-borrow
MLink Token	SRMLinkAnalytics
Product	SRAnalytics
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
ticker_at	enum - AssetType	PRI	'None'
ticker_ts	enum - TickerSrc	PRI	'None'
ticker_tk	VARCHAR(12)	PRI	''
clientFirm	VARCHAR(16)	PRI	''	clientFirm if clientFirm specific rates default SR system default rates
gcFlag	enum - YesNo		'None'	General collateral flag Yes No
gcRate	FLOAT		0	General collateral rate
borrowRate	FLOAT		0	StockBorrow rate
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
ticker_tk	1
ticker_at	2
ticker_ts	3
clientFirm	4

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRAnalytics`.`MsgStockBorrowRate`
WHERE 
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */ 
    `ticker_at` = 'None'
  AND
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */ 
    `ticker_ts` = 'None'
  AND
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='StockBorrowRate' ORDER BY ordinal_position ASC;